Exploring Load Balancing in Parallel Processing of Recursive Queries

نویسندگان

  • Sérgio Lifschitz
  • Alexandre Plastino
  • Celso C. Ribeiro
چکیده

Recent work on load balancing has connrmed its importance when one wants to achieve good performances during the actual evaluation of parallel database queries. Existing work mostly focuses on the join processing for parallel relational databases. We are interested here in more complex queries, such as recursive ones. The main diierence is that, in the latter case, the work due to a task cannot be previously determined and, consequently, no method can deene at the outset the tasks to be executed in parallel in order to balance the workload at each processor. We propose a dose-driven dynamic strategy that aims at obtaining an improved workload balance and better use of the available resources. We examine the applicability of our strategy with its specialization to the case of the transitive closure query. Preliminary computational results on randomly generated test problems illustrate the eeciency of the proposed method.

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Parallel Computation of Linear Recursive Queries in Knowledge-Based Systems

Parallel processing of recursive queries in KB systems is an important means to improve performance. However, two significant problems: heavy interprocessor communication and poor load balancing, are inherent features of query answering methods based on Least Fixed Point computation, such as Naive and Semi-Naive. They make it difficult to ensure efficiency for all distributions of data values. ...

متن کامل

Exploring Load Balancing in ParallelProcessing of

We study a dose-driven dynamic load balancing strategy to evaluate database recursive queries. This proposal aims at obtaining a good workload balance with full use of the available resources, with different kinds of skew considered. The strategy is intended for general recursive queries and preliminary computational results illustrate its ef-ciency when applied to the particular case of linear...

متن کامل

Parleda: a Library for Parallel Processing in Computational Geometry Applications

ParLeda is a software library that provides the basic primitives needed for parallel implementation of computational geometry applications. It can also be used in implementing a parallel application that uses geometric data structures. The parallel model that we use is based on a new heterogeneous parallel model named HBSP, which is based on BSP and is introduced here. ParLeda uses two main lib...

متن کامل

A Communications-oriented Methodology for Load Balancing in Parallel Relational Query Processing

The increasing amount of data manipulated in very large databases 1 and the complexity of the queries to be processed makes parallelism appear as one of the most promising research axes for future databases applications. Load balancing for relational operators has been widely studied and join algorithms including dynamic load balancing capabilities have been proposed 1]. However, for whole rela...

متن کامل

Analysis of Dynamic Load Balancing Strategies for Parallel Shared Nothing Database Systems

Parallel database systems have to support both inter-transaction as well as intra-transaction parallelism. Inter-transaction parallelism (multi-user mode) is required to achieve high throughput, in particular for OLTP transactions, and sufficient cost-effectiveness. Intra-transaction parallelism is a prerequisite for reducing the response time of complex and data-intensive transactions (queries...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 1997